UPDATE `mig_db`.`lib_template` SET `tags` = 'first_name,family_name,vehicle,seller,price,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email,stock_number,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email', `email_template` = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 <head>
 	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
 	<title></title>
 </head>
 <body style="padding:0;margin:0;">
 	<!-- Begin 100% Wrapping Table -->
 	<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
 		<tr>
 			<td style="padding:20px 0;">
 				<!-- Begin Main Template Table -->					
 				<table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">
 					<tr>
 						<td>
 						<img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
 						</td>
 					</tr>				
 					<tr>
 						<td style="background:#f6f6f6;padding:20px 0">
 							<!-- Main Content table -->
 							<table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
 								<tr>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 									<!-- Main Column -->
 									<td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
 										<h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Bid Successful</h1>
 										<p style="margin:0 0 1em;padding:0;">
 											&nbsp;
 										</p>
 										<p style="margin:0 0 1em;padding:0;">
 											Dear [first_name] [family_name],
 										</p>
 										<p style="margin:0 0 1em;padding:0;">
 											Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].
 										</p>
                     <p style="margin:0 0 1em;padding:0;">
                       <b>Your responsibilities:</b>
                       <ul>
                         <li>Complete sale within two working days.</li>
                         <li>Collect vehicle.</li>
                         <li>Sign attachments when collecting vehicle.</li>
                       </ul>
                     </p>
                     <p style="margin:0 0 1em;padding:0;">
                       <b>Seller:</b>
                       <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
                         <tr>
                           <td width="80px"><b>Trading Name:</b></td>
                           <td><b>[seller]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Full Name:</b></td>
                           <td><b>[seller_name]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Auction Address:</b></td>
                           <td><b>[vehicle_address]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Billing Address:</b></td>
                           <td><b>[seller_billing_address]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>VAT Number:</b></td>
                           <td><b>[seller_vat_number]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>E-mail:</b></td>
                           <td><b>[seller_email]</b></td>
                         </tr>
						 <tr>
                           <td width="80px"><b>Stock Number:</b></td>
                           <td><b>[stock_number]</b></td>
                         </tr>
                       </table>
                     </p>
					 
					 <br><br>
					 
					 <p style="margin:0 0 1em;padding:0;">
                       <b>Buyer:</b>
                       <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">
                         <tr>
                           <td width="80px"><b>Trading Name:</b></td>
                           <td><b>[buyer]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Full Name:</b></td>
                           <td><b>[buyer_name]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Physical Address:</b></td>
                           <td><b>[buyer_address]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>VAT Number:</b></td>
                           <td><b>[buyer_vat_number]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>Cellphone:</b></td>
                           <td><b>[buyer_mobile]</b></td>
                         </tr>
                         <tr>
                           <td width="80px"><b>E-mail:</b></td>
                           <td><b>[buyer_email]</b></td>
                         </tr>
                       </table>
					   
					   
                     </p>
                     <p style="margin:0 0 1em;padding:0;"><br/>
                       Regards,<br/>
                       The Bid4Cars Team
                     </p>
 									</td>
 									<!-- Spacing Column -->
 									<td width="40" valign="top" style="width:40px;">&nbsp;</td>
 									<!-- Side Column -->
 									<td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
 										<img src="{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />
 										<h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>
 										<p style="margin:0 0 1em;padding:5px;">
 											Online technology bringing buyers and sellers
 											together through the Dealer Network.
 										</p>			
 									</td>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 								</tr>
 							</table>
 							<!-- /Main Content Table -->			
 						</td>		
 					</tr>
 					<tr>
 						<td style="background:#ececec;padding:10px 0 0;">
 							<!-- Begin Footer table -->
 							<table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">
 								<tr>
 									<!-- Spacing Column -->
 									<td width="20" valign="top" style="width:20px;">&nbsp;</td>
 									<!-- Main Column -->
 									<td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">
 										<p style="margin:0 0 1em;padding:0;"><b>demo.bid4cars.co.za</b></p>
 									</td>
 									<!-- Spacing Column -->								
 									<td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>
 								</tr>
 							</table>
 							<!-- /End Footer Table -->	
 						</td>
 					</tr>				
 				</table>
 				<!-- /End Main Template Table -->
 			</td>
 		</tr>
 	</table>
 <!-- /End 100% Wrapping Table  -->	
 </body>
 </html>
 ' WHERE `lib_template`.`id` = 5;